/*
Output: Table 2. Mean Values by Engagement Group
*/



run "/Users/holyfantastic/Dropbox/Forest/Paper/Nature/FinalDocuments/Code/000declare_path" // change to your local path
  

use "ParcelLevelDataSept282023_VerNov82024_R1.dta" , clear

replace Landtr_Cut_mean_forest = Landtr_Cut_mean_forest *100

replace YearsOwned =. if YearsOwned < 0
replace dis_road = dis_road * 1000
label var YearsOwned ""
label var Landtr_Cut_mean_forest "Average annual percent forested area cut, 1985-2019"
label var forestAcres "Forest area (ha)"
label var dis_road "Distance to road, meters"
label var YearsOwned "Years owned"

global vars  ndvi1985   dndvi_1985_2019  Landtr_Cut_mean_forest Landtr_Cut_mean_forest8599 Landtr_Cut_mean_forest0014 Landtr_Cut_mean_forest1519 forestAcres  i.forestHaGroup dis_road i.roadGroup  YearsOwned i.yearGroup i.iPerson  i.iLocal 

table () group , statistic(mean $vars) nformat(%9.2f)


table () group, statistic(mean  $vars) nformat(%9.2f)


	collect export "$table/table_2_compare.xls", replace 
	
